<?php
/**
* @version		$Id: helper.php 10381 2008-06-01 03:35:53Z pasamio $
* @package		Joomla
* @copyright	Copyright (C) 2005 - 2008 Open Source Matters. All rights reserved.
* @license		GNU/GPL, see LICENSE.php
* Joomla! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/

// no direct access
defined('_JEXEC') or die('Restricted access');

class modportalreferenceHelper {

	function getportalreference(&$params){

		$db = JFactory::getDBO();
		
		$lim   = (int) $params->get( 'limit' );
		
		$lim0  = JRequest::getVar('limitstart', 0, '', 'int');
		$db->setQuery('SELECT SQL_CALC_FOUND_ROWS * FROM #__phocagallery WHERE catid=3 ORDER BY ordering',$lim0, $lim);
		$rL= $db->loadAssocList();
		if (empty($rL)) {return;}  
		else {
			////Here the beauty starts
			$db->setQuery('SELECT FOUND_ROWS();');  //no reloading the query! Just asking for total without limit
			jimport('joomla.html.pagination');
			$pageNav = new JPagination( $db->loadResult(), $lim0, $lim );
		}
		$result["link"] = $pageNav->getPagesLinks(); //Displays a nice footer
		$result["data"] = $rL;
		return $result;
		
	}
}
